package com.atguigu.tingshu.album.mapper;

import com.atguigu.tingshu.model.album.TrackInfo;
import com.atguigu.tingshu.query.album.TrackInfoQuery;
import com.atguigu.tingshu.vo.album.AlbumTrackListVo;
import com.atguigu.tingshu.vo.album.TrackListVo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface TrackInfoMapper extends BaseMapper<TrackInfo> {

    /**
     * 分页查看声音专辑列表
     *
     * @param page
     * @param trackInfoQuery
     * @return
     */
    IPage<TrackListVo> selectUserTrackPage(Page<TrackListVo> page, @Param("vo") TrackInfoQuery trackInfoQuery);

    /**
     * 声音对应的order_num 应该-1
     */
    @Update("update track_info set order_num = order_num - 1 where order_num > {orderNum} and album_id = #{albumId} and is_deleted = 0")
    void updateOrderNum(Integer orderNum, Long id);

    /**
     * 分页查询专辑声音
     *
     * @param albumTrackListVoPage
     * @param albumId
     * @return
     */
    @Select("select track.id trackId,\n" +
            "       track.track_title,\n" +
            "       track.media_duration,\n" +
            "       track.order_num,\n" +
            "       track.create_time,\n" +
            "       max(if(stat.stat_type = '0701', stat.stat_num, 0)) playStatNum,\n" +
            "       max(if(stat.stat_type = '0704', stat.stat_num, 0)) commentStatNum\n" +
            "       from track_info track inner join track_stat stat on track.id = stat.track_id\n" +
            "       where track.album_id = #{albumId} and track.is_deleted = 0 and track.status = '0501'\n" +
            "group by track.id\n")
    IPage<AlbumTrackListVo> selectAlbumTrackPage(Page<AlbumTrackListVo> albumTrackListVoPage, @Param("albumId") Long albumId);
}
